FaxPress Premier WebHelp: User Guide > Creating Phone Books

Creating Phone Books

Other Related Topics...

FaxPress Premier’s phone books provide convenient access to the contacts and fax numbers frequently used for fax addressing. The phone books can all be accessed from the Premier client’s Send Fax interface. See Sending Faxes for information on accessing the Send Fax interface.

The phone book groups include:

Personal Phone Books – These are individual FaxPress Premier phone books (per user) that you manage, and which are stored on the FaxPress Premier server. These are available (because they are stored on the FaxPress Premier server) to you no matter where you login to FaxPress Premier. Your personal phone books are located under the Mailbox branch in the Personal Phone Books folder.

Local Phone Books – These are individual FaxPress Premier or database phone books that you manage, and which are stored on your desktop. These are only available if you login to FaxPress Premier from your own workstation. Local Phone Books are managed through FaxPress Plus under the Personal Folders branch in the Local Phone Books folder. To access these phone books There are two types of Local Phone Books (as with Corporate Phone Books):FaxPress Phone Books and External Database Phone Books.

Corporate Phone Books – Corporate phone books are shared by all. They are created by the FaxPress Premier Administrator. They are accessed under the Corporate Phone Books branch for the general user. There are two different types of Corporate Phone Books:

the FaxPress Phone Books
External ODBC Database Phone Books.

For more information, refer to Creating Corporate Phone Books in the FaxPress Premier Administrator’s Guide.

Exchange and Outlook Contact Lists – You can access Exchange and Outlook contact list through FaxPress Plus, but you manage them through your email server or client. To access your contact lists for sending a fax, change your phone books options in your personal preferences to Exchange/Outlook. See Setting Personal Preferences.

Type of Phone Books

You have probably noticed by now that FaxPress Premier has two different types of phone books available within the phone book groups: FaxPress Premier Phone Books and External Database Phone Books.

FaxPress Phone BooksThe FaxPress Phonebooks are the internal phonebooks used by FaxPress Premier. All internal phonebooks can be imported and exported. FaxPress phone books can be managed from Local Phone Books, Personal Phone Books, and Corporate Phone Books. You can import, export and manually add users and groups to these phone books. The available file formats for importing into FaxPress Phone Books are:

Standard Comma Delimited Files (*.csv)
Custom Comma Delimited Files (*.csv)
dBase Files (*.dbf)
ExportPH Files (*.*)— This is a FaxPress Premier 3.x exported phone book

External ODBC Database PhonebooksFaxPress Premier can access your ODBC database phone books using an ODBC driver. The database can be many types, Microsoft Access, Microsoft SQL Server, or simply an Excel spreadsheet. You must have the specific ODBC driver loaded on your client machine to access these phone books through FaxPress Premier database phone books. Database access is available through both Corporate Phone Books and Local Phone Books.

Formatting Phone Numbers

The FaxPress Premier can be configured to automatically format phone numbers to include area codes, external line access, international codes, PBX codes and passwords. If you would rather embed all the dialing rules in your phonebooks, use the following phone number format information.

We recommend that numbers have separators between the various parts. Legal separators are:

A single or multiple space character(s)
A dash —
Brackets ( )

Other, non numeric characters which may be in an entered number are:

$ (Dollar sign)— FaxPress Premier replaces the PBX password with the dollar sign.
% —this can also be used for PBX password substitution.
# —by default this dials the # key like the one found on most phone keypads. This character can also be used as the separator character to indicate T.30 sub addressing.
*— by default this dials the * key like the one found on most phone keypads.
, (comma). This inserts a 3 second pause in the dialing. No comma is needed in the PBX pre dial; there is already an implied pause.

Creating Local Phone Books

Local Phone Books can contain either FaxPress Phone Books or Database Phone Books. You do not have to be logged in to the Premier to create or manage local phone books because they are stored on and accessed from your local workstation.

Create Local FaxPress Phone Books

To create a local FaxPress Phone Book, follow these steps:

1. Open FaxPress Plus. (Start>Programs>FaxPress>FaxPress Plus) and select the Contacts folder view.
2. Expand the Personal Folders branch and click on Local Phone Books to access the External Database Phone Books and FaxPress Phone Books.

 

 

3. Right click on FaxPress Phone Books and select Add Phone Book from the context menu.

 

4. Enter the name you want to give the new phone book in the Phone Book Name text box.
5. Click Browse to specify the path and filename of a new phonebook or an existing FaxPress Premier phonebook file in another directory. Otherwise, the file will have a default name and be stored in the C:\Documents and Settings\<username>\My Documents\My FaxPress\Local PhoneBooks directory on your desktop.
6. Click OK. A new folder will now be visible under the FaxPress Phone Books folder. You now either create a Group and add individual members or import a phonebook from a file.

Create a Local Phone Book Group

To create a local phone book group, follow these steps:

1. Right click on your new phonebook and select Add Group from the context menu.

 

Group names can be used when sending faxes to broadcast your fax to any number of recipients. Premier handles this as a single fax and in fact only creates one raster file. This can significantly reduce the time necessary to process faxes.

2. Enter a name for each group you want to define in the Add Group text box and click OK.
3. To add members to the group, right click on the Group name and select Add Member to bring up the Edit Member screen.

 

4. Fill in the Edit Member field with the appropriate information.

You can continue adding individual members, or you can import members into your phone book from an existing phone book file.

Import a Phone Book File

As stated in the introduction to this chapter, you can import four types of phone book files:

Standard Comma Delimited Files (*.csv)
Custom Comma Delimited Files (*.csv)
dBase Files (*.dbf)
ExportPH Files (*.*)— This is a FaxPress Premier 3.x exported phone book

To import a phone book file, follow these steps:

1. Follow the procedure in Create Local FaxPress Phone Books to create a FaxPress Premier Phone Book. But do not create a phone book group.
2. Right click on the phone book you have created and select Import and file format (i.e., CSV Default Format, CSV Custom Format, ExportPH, dBase) from the context menu.
3. If you are importing a CSV default format file, a dBase file, or a ExportPH file, an Open import file screen will provide you the means for locating the file.

If you are importing a dBase file, after you use the Open import file screen to locate your dBase file, the Convert dBase to Phone Book dialog box will be displayed. Use this dialog box to map the dBase fields (in Fields) to your FaxPress Premier fields (in Target Phone Book Fields).

Use the Add Link button to establish a link between the fields selected from the source dBase file and the target phone book (see above). The link is shown in the View list. Click on this button to remove selected item from the View list.

Click on the Convert button to start the conversion process.

4. If you are importing a CSV custom format file, the Import File Field Assignment window will be displayed before the Open import file screen.

 

The default values are 1 through 7 respectively. Re-sequence the fields to correspond to your custom file. If you do not have one of the default fields in your custom file, leave the field blank. In the figure above, the custom file does not have fields for Voice number, Comment or Group.

5. After to have located the file, click OK to import the file. The phone book number will all be located in the folder ALL (if not Group is defined in your imported file) or the Group name (defined in the import file) folder under your new FaxPress Phone Book.

Export a Local FaxPress Phone Book

To export a phonebook, follow these steps:

1. Open FaxPress Plus and select the Contacts folder view.
2. Click on Local Phone Books and right click on the phone book you want to export.
3. Select Export to open the Save As window. Navigate to a directory, specify a name, and save the file. The file will be exported as a comma delimited file.

 

ODBC Database Phone Book

FaxPress Premier also supports ODBC based external phone books. This allows you to connect to existing databases and use them as phone books for faxing. ODBC Phone Book support allows the administrator to:

Specify the external database to use as a FaxPress Premier phone book
Map FaxPress Premier phone book fields and data base fields
Create different views of the database by specifying filters

The administrator can create any number of corporate phone books. Each corporate phone book can connect to a different database and contain any number of views (filters) of that database. Views can be created, for example, to show a customer list in a specific state or country. ODBC Phone Book support provides a sophisticated yet intuitive user interface for the administrator to create all those views.

Once the views are created, they become visible to all the users. The end user can use the Corporate phone books in exactly the same way they use the FaxPress Premier native Corporate Phone Books. The end user can also create local ODBC Phone Books right from their desktop.

FaxPress Premier ODBC phone books can work with any ODBC compliant database, including:

Any SQL compliant DBMS servers, such as Microsoft SQL server, Oracle, Informix etc.
ISAM type databases such as: dBase, Excel, FoxPro, Microsoft Access database
Personal & Corporate Cover Pages

FaxPress Premier allows users to create their own cover pages while supporting a globally accessible corporate cover page. FaxPress Premier provides an easy-to-use cover page editor to facilitate the cover page creation process.

To access an external ODBC database, follow these steps:

1. Open FaxPress Plus and select the Contacts folder view.
2. Select Local Phone Books and right click on External Database Phone Books.
3. Select Add Database Phone Book from the context menu.

 

4. The Database Phone Book window is displayed. You can create a new phone book, give it a name and select the type and location of the database from this screen.

 

5. To connect to either an Microsoft Access database or an Excel, FoxPro or dBase database, enter or browse for a file name and path. If the database file is password protected, you need to provide this password.

The supported ISAM file formats are:

dBase versions III, IV, or V
Excel versions 3.0, 4.0, 5.0 and 8.0
FoxPro 2.0, 2.5, 3.0 and DBC
6. To connect to a DBMS server such as Microsoft SQL server, select an existing or create a new connection string. This is done by clicking the ‘select’ button. The local ODBC user interface comes up to allow you to select the “ODBC data source name”. For detailed instructions for navigating in your ODBC 32 Bit setup program, refer to the Reference section in this Guide.

Create Phone Book Views

To use an external database as a phone book, you must first link to the specified database and then create associations or mapping between the database fields (or columns) and the Phone book elements. The process of creating phone book views enables the mapping process.

To create new phone book views, follow these steps:

1. Right-click on the new database phone book and select Add View from the context menu.

 

2. The Database Phone Book window will be displayed.

 

From the Database Phone Book window you can select any table and column in your phone book database and associate it with a phone book field.

3. The Phone Book View tab will be activated by default. Use this tab to map the FaxPress Premier phone book fields to the external phone book. The following FaxPress Premier fields can be mapped into fields in the database phone book:
Table — The define tables in your database can be selected from the drop down list.
First Name and/or Last Name— To associate the fax recipient with the field or column in your table, select the appropriate column name from the drop down list. As in the example screen above, we have associated a LastName column in the phone book with the ContactName column in the Customers table.
Fax No. — {{Add}} fax number format requirements.

If your database table contains separate fields for country code, area code and number you will need to select those separately, by clicking the Build button to separately select each of those fields and put them together to generate the fax number.

Company — Map this phone book field to the equivalent CompanyName column in your database table. This is an optional field.
Bill Back Code— Map this phone book field to the equivalent BillBackCode column in your database table. This is an optional field.
4. To map the database table to your view, select one of the database tables in the scroll down list for Table.
5. Once you select the table, you will be able to select the table fields from the drop-down list boxes next to each of the FaxPress Premier phone book fields.

If your database table does not contain a separate fields for first and last name, just map one of them (either first or last name) to the full name, as shown above.

6. You can define a filter on the database by clicking on the Build Criteria button. The Criteria dialog box will be displayed.

 

As an example, you can set the criteria for all supplier in the United States by selecting “Country” for Field Name, “equals” for Operator, and “USA” for Value.

You can use either ‘Logical AND’ or ‘Logical OR’ to define the logical relationship between those conditions. The ‘Operator’ provides a rich variety of conditions such as: Begins with, Ends with, contains, does not contain etc.

7. You can view the SQL statement that is generated as a result of the mapping and the criteria that you have set by clicking on the SQL Statement button. This is an informational field only.
8. Click OK when you are finished filling out the Phone Book View tab and select the Dialing Rules tab.

 

9. To apply the dialing rules that have been defined in Server Properties for every fax number in this view, click the box.
10. Click OK to finish creating your view. The new view will be located under the phone book folder.

Create Table Joins

To access multiple tables from one phonebook view, you must include a new table in your view and define a join or an association between a column in one table with a column in the new table. You must define a join for each of the tables from which you want to include data for your phone book. At least one join has to be defined.

To create a table join, follow these steps:

1. Right click on any phone book view and select Properties from the context menu. The Phone Book View tab will be activated.

 

2. Select the table you want to join by finding it in the Table scroll down list. In the above screen the Employees table was added to the Contacts view.
3. Go to the FaxPress Premier field name that you want to map to this Table, and find the new table field. In our example, the Employee.FirstName and Employee.LastName were mapped to the appropriate FaxPress Premier fields. As soon as you enter a field from the new table the Table Joins button will now be activated.
4. Click on the Table Joins button to open the Table Joins window.

 

5. Select the tables you want to join in Table 1 and Table 2.
6. Select the field in Table 1 to join to the field in Table 2 in Field 1 and Field 2.
7. Click the Add Join button. The view now includes data from two different tables.

Build Fax Numbers

If your database table contains separate fields for country code, area code and number. To add each of those fields together to create the fax phone number, follow these steps:

1. Right click on any phone book view and select Properties from the context menu. The Phone Book View tab will be activated.
2. Click the Build button (to the right of Fax Number). The Build Fax Number dialog box will be displayed.

 

3. To have FaxPress Premier automatically build a fax number, map the following FaxPress Premier fields to the fields in your database table.
Table— The table that contains the phone number fields
Country Code— The country code to include with the fax number
Area Code— The area code to include with the fax number.
Fax Number— The base number to include with the fax number.

FaxPress Premier will now automatically generate your fax numbers.

 

FaxPress Premier WebHelp
Last Updated: 11/1/2007
 

E-mail this page

Castelle

855 Jarvis Drive, Suite 100

Morgan Hill, CA 95037

Toll-free 800.289.7555

Tel 408.852.8000

Fax 408.852.8100

www.castelle.com